Lo_analysis
Hannah Lo
12/10/2019
Background
I am working with two datasets. The first contains cost of living information for major United States cities in 2018. It has 132 cities and two corresponding values. The first is called ‘rent index’ this index is relative to New York City. For New York City, all indecies are 100. For example, if another city has a rent index of 120, this means on average that cities rent is 20% more expensive than New York City. The other value is cost of living which is the
Cleaning
Prep work on cost_of_living data and connected it to lat and long data for mapping.
cost = cost[-1]
cost = separate(cost, City, into = c("city", "state","country"), sep = ',')
cost = cost[-3]
cost = separate(cost, state, into = c("delete", "state"), sep = ' ')
cost = cost[-2]
cost$state = abbr2state(cost$state)
convert = convert[,c(1,4,9,10)]
convert$state = convert$state_name
convert = convert[-2]
cost_map = left_join(cost,convert,by = c("city","state"))
str(cost_map)## 'data.frame': 132 obs. of 6 variables:
## $ city : chr "New York" "San Francisco" "Anchorage" "Honolulu" ...
## $ state : chr "New York" "California" "Alaska" "Hawaii" ...
## $ Cost.of.Living.Index: num 100 97.8 95 94.2 93.8 ...
## $ Rent.Index : num 100 115.4 40.1 62.8 76.2 ...
## $ lat : num 40.7 37.8 61.2 21.3 40.7 ...
## $ lng : num -73.9 -122.4 -149.1 -157.8 -73.9 ...Rent Index
Cost of living
Comparison
Min wage
References
- class lecture notes
- https://plot.ly/r/choropleth-maps/
- https://stackoverflow.com/questions/29037851/how-do-i-plot-us-cities-using-ggplot
- https://garrettgman.github.io/tidying/
- https://stackoverflow.com/questions/5411979/state-name-to-abbreviation-in-r
- https://rdrr.io/cran/openintro/man/abbr2state.html
- https://community.rstudio.com/t/how-to-add-my-api-key-into-get-map/15992/5
- https://www.datanovia.com/en/blog/top-r-color-palettes-to-know-for-great-data-visualization/
- https://www.r-graph-gallery.com/13-scatter-plot.html
- https://stackoverflow.com/questions/39123458/how-does-cut-with-breaks-work-in-r
- https://stackoverflow.com/questions/45868625/how-to-reverse-the-default-color-palette-for-ggplot2/45869032#45869032
- https://www.rforexcelusers.com/vlookup-in-r/
- https://ggplot2.tidyverse.org/reference/scale_colour_continuous.html
- https://plot.ly/ggplot2/
- https://plot.ly/ggplot2/interactive-tooltip/
- https://stackoverflow.com/questions/43515112/reversing-default-scale-gradient-ggplot2
- https://plot.ly/r/scatter-plots-on-maps/
- https://stackoverflow.com/questions/18115550/combine-two-or-more-columns-in-a-dataframe-into-a-new-column-with-a-new-name
- For the convert data : https://simplemaps.com/data/us-cities
- For the tuition data : https://nces.ed.gov/programs/digest/d18/tables/dt18_330.10.asp
- For the min_ wage data : https://www.dol.gov/whd/state/stateMinWageHis.htm
- For the cost_liv data : https://www.numbeo.com/cost-of-living/region_rankings.jsp?title=2018®ion=021